5. Emissions By Year: We will be building No 5 of the below dashboard:
The below screenshot shows what is expected to be built after following the steps below:
Use the GIF below to add the Shape Map
Format shape map - Instructions and screenshots are below:
1.
Click on the format tab
2.
Click on General
3.
Adjust X position to 839
4.
Adjust Y position to 168
5.
Adjust Width to 440
6.
Adjust Height to 277
7.
Click on data color
8.
Turn Diverging "On"
9.
Change Minimum color to #E6E6E6 by clicking
on it ---> More colors--> Copy and paste #E6E6E6
10. Change Center color to #F0E199
11. Change Maximum color to #E68FBF
12. Insert 8 for Minimum
13. Insert 16 for Center
14.Insert 32 for Maximum
15.Turn Title "On"
16.Change Text to Emissions Per Capita - Tonnes Per
Person
17.Change font color to White
18.Change background color to #666666
19.Change Alignment to Center
20.Change Text size to 9
Title Font is Segoe UI Semibold
After all the format, you will notice that some countries are
greyed out, this is because there is a mismatch of name between our data and
the shape map. For example; United States in our data is United States of
America in the Shape Map.
Repeat the same steps for the following countries and for all
tables that have Country columns: GHG Emissions table, World Population table and Continent_Country tables.
After all countries should have been populated, go to format
tab, click on Default color, click on show, and turn "off" to turn
off regions/countries not in our data.
To create Legend for our Shape Map, Copy the section
with the diverging color as shown below, save on your computer. Go to Insert
and click on Image to bring in the image, resize and drag it to right bottom
part of the Map visual
Copy the legend and save the legend Position for the Legend:
To create low-high as shown below, insert a text box, type in
Low and High as shown below and drag it below the legend
Drag it to the visual and
resize as follows;
You should have the below screenshot after using the steps above.
